proc = """ DELIMITER //
CREATE PROCEDURE InsReview_wFkey(
  IN  Reviewer VARCHAR(255),
  OUT AlbumID INT,
  IN  StartDate TIMESTAMP,
  IN  SubmissionDate DATETIME,
  IN  ReviewerComment TEXT,
  IN  Director VARCHAR(255),
  IN  Approved BOOLEAN,
  IN  ApproveDate DATETIME,
  IN  DirectorComment TEXT,
  )

BEGIN
        INSERT INTO Review(

                          )
        VALUES (

               );
              
#fix this here
        SELECT DISTINCT Artist.artistId FROM Artist WHERE artistName = Artist.artistName INTO artistID; 
        END //
DELIMITER ;
        """

